Returns a recordset object opened from a datasheet. The value is generally assigned to a variable for use with database statements, such as GetRowValue.
Note: A primary key must be defined in the table if you want to add or update rows. If a primary key is not defined, QA Wizard Pro opens the table as read-only.
Syntax
OpenRecordset("DatasheetName")
Arguments
Argument | Description |
---|---|
DatasheetName | Local or external datasheet to open. Must be in the current workspace. |
Return value
Value | Description |
---|---|
Value | Recordset object opened from the datasheet. |
Example
bugs = OpenRecordset("WysiCorp Bugs")
product = GetRowValue(bugs, "Product")